点击查询：

 

 

下面先上html页面:

 

     
     
     
     
     
         
     
        
      
约见列表
        
      
            
       
                
                        
                        
                                        
        
                    
         标 &nbsp题：                    
                         
        
                
        查  询                            
       
            
      
            
                  
      
      
                   
                    
                         
                                   
                         
编号
                         
约见标题
                         
姓名
                         
所属地区
                         
创建时间
                         
操作
                    
                   
                   
                    
                         
                                     
                         
{$vo.userid}
                         
{$vo.title}
                         
{$vo.username}
                         
{$vo.name}
                         
{$vo.pubtime|date='Y-m-d',###}
                                         
删除
                    
                               
                   
                    
         
{$page}
                    
       
              
    
     
    

再上jquery代码：

 

最后上php代码：

 

public function search()    {       $title=$_POST['title'];       if($title)       {            $moden=M('meet');            import("ORG.Util.Page");            $count= $moden->where("title='$title'")->count();            $Page= new Page($count,17);            $show= $Page->show();            $sql="select userid,username,city_id,name ,title,pubtime from meet,region where title='$title' and id=city_id order by userid desc limit $Page->firstRow, $Page->listRows";            //$sql="select userid,username,city_id,name ,title,age,height,sex,telephone,education_id,professional,month_salary,weixin,pubtime from meet,region where title='$title' and id=city_id order by userid desc limit $Page->firstRow, $Page->listRows";            $rs=$moden->query($sql);            if($rs)            {                foreach ($rs as $k => $v)                {                    $rs[$k]['sex']=$v['sex']==1?'女':'男';                    $rs[$k]['pubtime']= date('Y-m-d', $rs[$k]['pubtime']);                }                $json = array(                    'page' => $show,                    'data' => $rs                );                echo json_encode($json);            }else            {                echo '0';            }       }            }